﻿using System;
using Microsoft.EntityFrameworkCore.Migrations;

#nullable disable

namespace KWT.DRG_DIP.API.Migrations
{
    /// <inheritdoc />
    public partial class _20250415105040 : Migration
    {
        /// <inheritdoc />
        protected override void Up(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.CreateTable(
                name: "Sys_Contents_Para",
                columns: table => new
                {
                    ParaID = table.Column<string>(type: "varchar(255)", nullable: false, comment: "")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Disease_Code = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "病种编码")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Type = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "类别")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Code = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "编码")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Name = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    Ratio = table.Column<decimal>(type: "decimal(18,6)", precision: 6, nullable: false, comment: "调节系数"),
                    ZGDZ = table.Column<decimal>(type: "decimal(18,6)", precision: 6, nullable: false, comment: "职工点值"),
                    JMDZ = table.Column<decimal>(type: "decimal(18,6)", precision: 6, nullable: false, comment: "居民点值"),
                    ZGFFBZ = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "职工付费标准"),
                    JMFFBZ = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "居民付费标准"),
                    LJFY = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "例均费用"),
                    ZYTSBGZ = table.Column<decimal>(type: "decimal(18,2)", nullable: false, comment: "住院天数标杆值(天)"),
                    HighMag = table.Column<decimal>(type: "decimal(18,1)", precision: 1, nullable: false, comment: "高倍率"),
                    LowMag = table.Column<decimal>(type: "decimal(18,1)", precision: 1, nullable: false, comment: "低倍率"),
                    Sort = table.Column<int>(type: "int", nullable: false, comment: "排序"),
                    AddUserID = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人ID")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    AddUserName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    AddTime = table.Column<DateTime>(type: "datetime(0)", precision: 0, nullable: false, defaultValueSql: "now()", comment: "创建时间"),
                    UpdUserID = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人ID")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    UpdUserName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    UpdTime = table.Column<DateTime>(type: "datetime(0)", precision: 0, nullable: true, comment: "最后修改时间"),
                    DelUserID = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人ID")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    DelUserName = table.Column<string>(type: "varchar(256)", maxLength: 256, nullable: false, defaultValue: "", comment: "创建人名称")
                        .Annotation("MySql:CharSet", "utf8mb4"),
                    DelTime = table.Column<DateTime>(type: "datetime(0)", precision: 0, nullable: true, comment: "软删除时间"),
                    IsDel = table.Column<bool>(type: "tinyint(1)", nullable: false, defaultValue: false, comment: "是否软删除")
                },
                constraints: table =>
                {
                    table.PrimaryKey("PK_Sys_Contents_Para", x => x.ParaID);
                },
                comment: "辅助目录-标杆")
                .Annotation("MySql:CharSet", "utf8mb4");
        }

        /// <inheritdoc />
        protected override void Down(MigrationBuilder migrationBuilder)
        {
            migrationBuilder.DropTable(
                name: "Sys_Contents_Para");
        }
    }
}
